MacWorld 1998 January

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1998 January / Macworld (1998-01).dmg / FileMaker Pro 4 / FM4 Templates w⁄data / Business / Inventory System / Product Sales (.txt) < prev

Wrap

FileMaker Pro Database | 1997-09-14 | 147KB | 965 lines

rek! s374 0 franken.diskussion! s206 1 franken.fundgrube! s945 0 fras._wichtig! s2 1 fras.mini-bins! s338 1 fras.text.allgemein! s2505 0 fras.text.hardware! s142 0 fras.text.networking! s15 1 fras.text.programmieren! s124 1 fras.text.spiele! s45 1 frednet.general! s123 1 free.activism.walmart! s11 0 free.alt.config! s10 1 free.alt.iran.irc! s7 0 free.biz.config! s8 1 free.comp.config! 1 free.lunch.no-such-thing! s81 0 free.misc.config! s4 1 free.news.answers.why-free! s12 0 HBAM2016AUG95 Pro 3.0 le.gardens! s2230 0 triangle.gardesn! 1 triangle.general! s22370 0 triangle.graphics! s214 1 triangle.jobs! s11858 0 triangle.libsci! s137 1 triangle.motss! s1735 0 triangle.movies! s812 0 triangle.neural-nets! s115 0 triangle.online-access! s382 0 triangle.personals! s721 0 triangle.personals.bi! s152 0 triangle.personals.foo! s13 0 triangle.personals.friendship! s44 1 triangle.personals.m-seeking-m! s83 0 triangle.personals.m-seeking-w! s58 0 triangle .wizards! s131 1 trumpet.announce! s295 0 trumpet.bugs! s416 0 trumpet.feedback! s273 0 trumpet.questions! s3656 0 trumpet.test! s255 0 tub.general! s28 1 tub.wanted! s83 1 tum.general! s15 0 tum.info.general! s16 1 tum.info.inst.mitteilungen! s3 1 tvontario.teleguide! s349 0 tw.announce! s493 1 tw.bbs.admin! s79 0 tw.bbs.admin.installbbs! s2359 0 tw.bbs.alumni! s3938 0 tw.bbs.alumni.chengkung! s314 0 tw.bbs.alumni.chien-kuo-hs! s2265 0 tw.bbs.alumni.chingmei! s70 0 tw.bbs.alumni.chungli! s133 0 tw.bbs.alumni.cy! s886 0 tw.bbs.alumni.hch HBAM3016AUG95@ HP DeskJet 540 Printer Pro 2.0 - 2.1F! Pro 3.0 FileMaker Pro 3.0 Folder AMOUNT DUE AMOUNT PAID CREATED BY CUSTOMER ADDRESS CUSTOMER CITY CUSTOMER COMPANY CUSTOMER COUNTRY CUSTOMER FAX CUSTOMER ID CUSTOMER NAME CUSTOMER PHONE CUSTOMER STATE CUSTOMER ZIP CODE DATE CREATED DATE MODIFIED DISCOUNT DISCOUNT RATE F.O.B. INVOICE DATE INVOICE ID INVOICE TOTAL LAST LAYOUT L SALES TAX SALES TAX RATE - SHIP DATE SHIP VIA SHIPPING SHIPPING RATE SUBTOTAL TERMS WEIGHT Invoice IDB Customer NameB Invoice DateB Customer AddressB Customer State Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 7/29/975 Description Use this database file to track purchase orders. FileMaker Pro automatically calculates sales tax and product discounts. How to use this solution You can update the sales tax and discount rate by updating the values in those fields How to customize this solution You can look up the customer information from your own Customers file based on the Customer ID field. You can create a new file with your shippers rates by ZIP Code, and then redefine the Shipping Rate field to autoB:matically look up the rate based on the Customer ZIP Code. Form View - Sale A List View Invoice Report Information Report Menu @?A!Form View - Customer and Shipping Form View - SaleB Customer ZIP CodeB Date CreatedB Date ModifiedB Customer CityB Customer CompanyB SubtotalB Sales Tax RateB .A Sales TaxB 4) * ShippingB Invoice TotalB Discount RateB DiscountB 7A Ship DateB TermsB Net 30 F.O.B.B Ship ViaB Ground WeightB Created ByB InfoB Customer IDB Amount PaidB Amount DueB Customer CountryB Shipping RateB Customer PhoneB Customer FaxB Last LayoutB Joel DavisE 5/5/95G 2301 Pennings CircleH 87154Y 10/5/95` Santa Fea Acme Industriesm 5/25/95x Net 30y New Yorkz Ground 216.68 505-555-6472 505-555-6438 George RahallE 10/5/95G 1782 W. 18th St.H 98668X 10/5/95Y 10/7/95` Vancouvera The Art Gallerym 10/5/95x Net 30z Ground| Paul Farrah 206-555-1219 Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Enter data for Product Sales Close View As View As Reports Record Delete Record Record Your Own Button Your Own Button Customer & Shipping Product Sales Line Items File... Inventory File... Invoice ID Invoice Date Subtotal Discount Shipping Total Prod. ID Description Price Extended Amount Subtotal Discount Shipping Total Prod. ID Description Price Extended Amount Cust. ID Company Amount Paid Amount Due Discount Rate Tax Rate Ship Date Terms A List ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Totalb Customer Namec Dated Invoice IDe&Click to see more information for Salef Infog Closeh View As Formi View As Listj Reportsk Recordl Delete Recordm Recordn Your Own Buttono Your Own Button Customer Company u Ship Date Invoice ReportB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Extended Amount Price Quantity Description Weight Invoice Total Shipping Discount Subtotal Ship Via n Ship Date F.O.B. Terms Extended Amount Price Quantity Description Weight Invoice Total Shipping Discount Subtotal Ship Via n Ship Date F.O.B. Terms Customer Invoice Date Invoice Company Name and Logo Close View As View As Reports Your Own Button ABCA>>, << ABAI>> << ABAK>> ABEG>> Invoice ID Product ID InformationB P-Information about the Purchase Sales solutionQ Info for this SolutionS InfoT CloseU View As FormV View As ListW ReportsX Your Own Button Report MenuB Report MenuB Your Own ReportI Your Own ReportJ InvoiceK Your Own ReportL>Click on any of these buttons to preview the respective reportM Select a reportN InfoO CloseP View As FormQ View As ListR ReportsS Your Own Button - of these buttons to preview the respective reportM Select a reportN InfoO CloseP View As FormQ View As ListR ReportsS Your Own Button InfoO CloseP View As FormQ View As ListR ReportsS Your Own Button A!Form View - Customer and ShippingB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Invoice Date Invoice ID Enter data for Product Sales Close View As View As Reports Record Delete Record Record Your Own Button Your Own Button Product Sales Inventory File... Line Items File... Company Address City / State / ZIP Code Country Customer & Shipping Shipping: Rate ($/lb) Weight (lbs) Ship Date Ship Via F.O.B. Customer Shipping Phone InfoO CloseP View As FormQ View As ListR ReportsS Your Own Button )=400 Cancel You did not enter any find criteria; all records will be displayed.C) Cancel No records match this request.E+ ) = 1 Sort by Sold To Name Open Inventory File Dial Phone Information A List View Report Menu Helvetica Geneva Times Times New Roman Arial MS Sans Serif Information List View Report Menu Open Inventory File Sort by Date Sort by Sold To Company Sort by Sold To Name Invoice Report Open Script Dial Phone Sort by Date Invoice Report Sort by Sold To Company Open Script wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Ejwwg wwxwwxw >RPTH FPTHA>HARDDISK:CONSULT:ClarisII:KenMahlr:inbox:95-10-04:Productl.fp3 NAMEA Productl.fp3 RPTHA Productl.fp3 WSPCA-C:\CONSULT\ClarisII\KenMahlr\inbox\95-10-04\ HNAME FPTHAHHARDDISK:CONSULT:ClarisII:KenMahlr:inbox:95-10-04:Product Line Items.fp3 NAMEA Product Line Items.fp3 RPTHA Product Line Items.fp3 SRPTA prod_itm.fp3 inbox\95-10-04\ GRPTH FPTHAGHARDDISK:CONSULT:ClarisII:KenMahlr:inbox:95-10-04:Product Inventory.fp3 NAMEA Product Inventory.fp3 RPTHA Product Inventory.fp3 WSPCA-C:\CONSULT\ClarisII\KenMahlr\inbox\95-10-04\ (LIST LISTA Ground VDEFA( ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 wwwwww UUUUUU DDDDDD """""" UUUUUU wwwwww (*)(%,3& )%+@6) ",30,)% #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,* !$&(265389,#!$$ '275? " $$*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:< /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)! //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+,)+" &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10// 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!PQ 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0%&' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFGCA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9< 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,027CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 876=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*, 169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,*3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7) !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364,M4%"!!"560&)/<9;989;>3$ "03., PQ wwwwww ffffff UUUUUU DDDDDD 333333 wwwwww ffffff UUUUUU DDDDDD 333333 wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" "%UR UD33D #4EWp "4EVx #3EVg "4DUg #3EVg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww wwwwww ffffff UUUUUU DDDDDD 3333B """""" B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"#C0 4""#C0 AD@D@ AD@D@ AD@BL 44444 CCCCC 44444 CCCCC $42" @@BA@ WSPC@ bRBBP0 ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 333333 wwwwww UUUUUU DDDDDD """""" FMRLA Product Line Items (LIST LISTA Net 7 Net 14 Net 30 VDEFA( (LIST VDEFA( Ship Via ListB Terms ListC Product List WSPCA-C:\CONSULT\ClarisII\KenMahlr\inbox\95-10-04\ GNAME FPTHAGHARDDISK:CONSULT:ClarisII:KenMahlr:inbox:95-10-04:Product Inventory.fp3 NAMEA Product Inventory.fp3 RPTHA Product Inventory.fp3 SRPTA prod_inv.fp3 WSPCA-C:\CONSULT\ClarisII\KenMahlr\inbox\95-10-04\ (LIST LISTA Ground VDEFA(